Quiz: Calculated Fields

Task Description:

Tasks to complete:

Task List:

Assure you are on a new worksheet.

From the Profit drop down, select Create > Calculated Field....

Change Calculation1 to Profit per Item, and the equation to [Profit]/[Quantity]. Name this Profit per Item. Hit OK.

Notice your new column exists within the measures.

Move Profit per Item to the Columns, and change to AVG aggregator. Move Sub-Category to the Rows.

Quiz 1 below.

Assure you are on a new worksheet.

From the Quantity drop down, select Create > Calculated Field....

Change Calculation1 to Quantity Factor, and complete Quizzes 2 and 3 below to assist with the statement you will write next.

Quiz 2 below.

Quiz 3 below.

Write an IIF Statement for 'High', 'Medium', and 'Low' categories of Quantity Factor with cutoffs at 3 and 8.

Move the Quantity Factor to the Rows and Category to the Columns.

In the drop down menu on Quantity Factor select Measure > count.

Move another Quantity Factor to the Columns. My image is at the bottom for your reference.

Quiz 4 below.

Task Feedback:

Nice job!

QUIZ QUESTION::

Quiz 1

Move each Sub-Category item to its corresponding description.

ANSWER CHOICES:

Description	Sub-Category
Fasteners
Tables
Chairs
Copiers

SOLUTION:

Description	Sub-Category
Fasteners
Tables
Chairs
Copiers

QUIZ QUESTION::

Quiz 2

For the calculated field of IIF([Quantity] < 2, 'Low', 'High') match the following values to their corresponding result.

ANSWER CHOICES:

Value	Result
'Low'
Error
'Low'
Error
'High'
'High'

SOLUTION:

Value	Result
'Low'
'Low'
'Low'
'Low'
'High'
'High'
'High'
'High'

QUIZ QUESTION::

Quiz 3

For the calculated field of IIF([Quantity] < 2, 'Low', IIF([Quantity] < 5, 'Medium', 'High')) match the following values to their corresponding result.

ANSWER CHOICES:

Value	Result
'Medium'
'Medium'
'Low'
'High'
Error
'Low'
'Low'
'Medium'

SOLUTION:

Value	Result
'Medium'
'Medium'
'Medium'
'Medium'
'Low'
'Low'
'High'
'Low'
'Low'
'Low'
'Low'
'Medium'
'Medium'

SOLUTION:

Most orders have between 3 and 8 items sold.